--------------------------------------------------------------------------------------
      name:  <unnamed>
       log:  /Users/jz981/Google Drive/Celebrity_Politics_JZ_JT/Deliverables/celebrity
> _analysis.log
  log type:  text
 opened on:   2 Apr 2019, 13:09:19

. set more off 

. 
. use "celebrity_perspectives_data.dta"

. 
. *************************
. * How to produce TABLE 1
. *************************
. drop if endorsed=="unclear"
(3,201 observations deleted)

. drop if endorsed=="none"
(3,227 observations deleted)

. 
. gen observation = 1

. 
. * Row 1:
. tabstat observation, s(sum)

    variable |       sum
-------------+----------
 observation |    222801
------------------------

. * Number of tweets: 222,801
. 
. gen any_candidate_mentioned = (mentionsHillary==1 | mentionsTrump==1 | mentionsBerni
> e==1)

. 
. * Row 6:
. tabstat observation if any_candidate_mentioned==1, s(sum)

    variable |       sum
-------------+----------
 observation |      9869
------------------------

. * Number of tweets that mention one of the candidates (incl. RTs): 9,869
. 
. keep if is_retweet==0
(62,440 observations deleted)

. 
. * Row 2:
. * Number of tweets remaining: 160,361
. 
. encode endorsed, gen(endorse_N)

. encode screen_name, gen(c_id)

. 
. * Rows 3,4,5 of Table 1:
. tabstat observation if endorsed=="Clinton", s(sum)

    variable |       sum
-------------+----------
 observation |    124865
------------------------

. tabstat observation if endorsed=="Trump", s(sum)

    variable |       sum
-------------+----------
 observation |     23755
------------------------

. tabstat observation if endorsed=="Sanders", s(sum)

    variable |       sum
-------------+----------
 observation |     11740
------------------------

. 
. * Row 7:
. tabstat observation if any_candidate_mentioned==1, s(sum)

    variable |       sum
-------------+----------
 observation |      4403
------------------------

. 
. 
. * Prepare dataset for regressions
. gen date = dofc(created_at)

. gen year = year(date)

. 
. 
. * Calculate standardized RTs:
. egen avg_celeb_RTs = mean(retweet_count), by(screen_name)

. egen sd_celeb_RTs = sd(retweet_count), by(screen_name)
(1 missing value generated)

. 
. gen standardized_rt = (retweet_count - avg_celeb_RTs) / sd_celeb_RTs
(1 missing value generated)

. 
. *hist standardized_rt, by(mentionsTrump)
. 
. * By candidate mention
. tabstat standardized_rt retweet_count if endorsed=="Clinton", by(mentionsHillary) s(
> mean)

Summary statistics: mean
  by categories of: mentionsHillary 

mentionsHillary |  standa~t  retwee~t
----------------+--------------------
              0 | -.0024153  907.9617
              1 |  .3759856  839.2936
----------------+--------------------
          Total | -1.50e-10  907.5234
-------------------------------------

. 
. 
. *****************
. * PREPARE TABLE 2
. *****************
. 
. eststo clear

. eststo: reg standardized_rt mentionsTrump mentionsHillary mentionsBernie i.year i.c_
> id,r

Linear regression                               Number of obs     =    160,360
                                                F(94, 160265)     =      86.70
                                                Prob > F          =     0.0000
                                                R-squared         =     0.0124
                                                Root MSE          =     .99382

----------------------------------------------------------------------------------
                 |               Robust
 standardized_rt |      Coef.   Std. Err.      t    P>|t|     [95% Conf. Interval]
-----------------+----------------------------------------------------------------
   mentionsTrump |   .3590813   .0314102    11.43   0.000      .297518    .4206446
 mentionsHillary |    .300943   .0607075     4.96   0.000     .1819577    .4199284
  mentionsBernie |   .2630194   .1531795     1.72   0.086    -.0372091     .563248
                 |
            year |
           2009  |    .099871   .0707022     1.41   0.158    -.0387039    .2384458
           2010  |    .054436    .068807     0.79   0.429    -.0804243    .1892963
           2011  |   .1608236   .0693698     2.32   0.020     .0248603    .2967869
           2012  |   .3584955   .0690945     5.19   0.000     .2230718    .4939193
           2013  |   .4258265   .0676448     6.30   0.000     .2932441    .5584089
           2014  |   .5073526   .0686177     7.39   0.000     .3728633    .6418419
           2015  |    .603664   .0686868     8.79   0.000     .4690393    .7382887
           2016  |   .6661836   .0690912     9.64   0.000     .5307663    .8016009
           2017  |   .6658293   .0694761     9.58   0.000     .5296576    .8020011
           2018  |   .6603772   .0696692     9.48   0.000      .523827    .7969274
                 |
            c_id |
 _juliannemoore  |  -.0807756   .0340205    -2.37   0.018     -.147455   -.0140962
   abbijacobson  |   .1352167   .0308665     4.38   0.000     .0747189    .1957145
    abbywambach  |  -.0185938   .0272882    -0.68   0.496     -.072078    .0348904
          adele  |   .1355966   .0598228     2.27   0.023     .0183453     .252848
 americaferrera  |  -.0186557   .0296574    -0.63   0.529    -.0767835    .0394721
     amyschumer  |  -.1172053   .0299604    -3.91   0.000    -.1759272   -.0584835
      bad_robot  |   .0121865   .0341428     0.36   0.721    -.0547327    .0791056
barbrastreisand  |   -.066837   .0312808    -2.14   0.033    -.1281467   -.0055273
      bethbehrs  |  -.1567801   .0310218    -5.05   0.000    -.2175823    -.095978
        beyonce  |   .0664786    .283033     0.23   0.814    -.4882601    .6212174
        bonjovi  |   .1151029   .0278706     4.13   0.000      .060477    .1697288
    carole_king  |   .0489982   .0306084     1.60   0.109    -.0109936    .1089899
 charlizeafrica  |   .2487287    .034525     7.20   0.000     .1810605    .3163969
           cher  |  -.2268449   .0295652    -7.67   0.000     -.284792   -.1688977
   chloegmoretz  |  -.1596671   .0300947    -5.31   0.000     -.218652   -.1006821
  conniebritton  |  -.0924291   .0382357    -2.42   0.016    -.1673702    -.017488
    dannydevito  |   .2074848   .0316919     6.55   0.000     .1453693    .2696004
       ddlovato  |  -.1450787   .0303252    -4.78   0.000    -.2045154   -.0856421
   debramessing  |  -.1658675   .0421321    -3.94   0.000    -.2484454   -.0832895
   dennisrodman  |  -.1136484   .0280436    -4.05   0.000    -.1686133   -.0586835
  dratzenberger  |   .0701064   .0424368     1.65   0.099    -.0130688    .1532817
 elizabethbanks  |  -.1436115   .0303641    -4.73   0.000    -.2031244   -.0840986
  eltonofficial  |  -.1142895   .0310441    -3.68   0.000    -.1751352   -.0534437
         emrata  |  -.0598935   .0322595    -1.86   0.063    -.1231213    .0033344
    evalongoria  |  -.1553813    .030341    -5.12   0.000     -.214849   -.0959136
    georgetakei  |  -.1773982    .031337    -5.66   0.000    -.2388181   -.1159783
     hereisgina  |  -.1516205   .0326748    -4.64   0.000    -.2156624   -.0875787
   iamjamiefoxx  |   .0264433   .0299269     0.88   0.377    -.0322128    .0850995
 iamsteveharvey  |  -.1523691   .0301167    -5.06   0.000    -.2113973    -.093341
imangelabassett  |  -.0712137    .034257    -2.08   0.038    -.1383568   -.0040706
     jaime_king  |  -.1614256    .029898    -5.40   0.000     -.220025   -.1028261
            jlo  |  -.1531173   .0336278    -4.55   0.000    -.2190271   -.0872076
     johnlegend  |  -.1791661   .0307203    -5.83   0.000    -.2393773   -.1189549
      jonvoight  |  -.3433198   .2548776    -1.35   0.178    -.8428745    .1562348
     justinlong  |  -.0603102    .037384    -1.61   0.107    -.1335821    .0129616
          kaj33  |   .1939143    .031117     6.23   0.000     .1329257    .2549028
      katyperry  |  -.1300365   .0286733    -4.54   0.000    -.1862356   -.0738374
kerrywashington  |  -.1502252   .0305673    -4.91   0.000    -.2101365   -.0903139
  kimkardashian  |  -.1500059   .0316653    -4.74   0.000    -.2120692   -.0879425
      kingjames  |  -.0065959   .0271711    -0.24   0.808    -.0598507    .0466589
       ladygaga  |  -.1127279    .029373    -3.84   0.000    -.1702984   -.0551574
  leedanielsent  |  -.1527317   .0304784    -5.01   0.000    -.2124688   -.0929946
     lenadunham  |   -.145392    .029275    -4.97   0.000    -.2027703   -.0880137
    leodicaprio  |   .0464597   .0421016     1.10   0.270    -.0360586     .128978
        madonna  |  -.0701119   .0278471    -2.52   0.012    -.1246917   -.0155321
   magicjohnson  |  -.1372187   .0282004    -4.87   0.000    -.1924909   -.0819466
    mariahcarey  |  -.0762317   .0296701    -2.57   0.010    -.1343845   -.0180788
    markruffalo  |   -.185087   .0455759    -4.06   0.000    -.2744148   -.0957592
marysteenburgen  |  -.0961352   .0310868    -3.09   0.002    -.1570647   -.0352057
      miafarrow  |  -.2279786   .0368181    -6.19   0.000    -.3001413    -.155816
     mileycyrus  |  -.0661152   .0290584    -2.28   0.023     -.123069   -.0091614
         mjfree  |  -.2127496   .0299347    -7.11   0.000     -.271421   -.1540782
           mw55  |  -.1516863   .0294066    -5.16   0.000    -.2093225   -.0940501
    officialkat  |  -.0300428   .0285175    -1.05   0.292    -.0859364    .0258508
    oliviawilde  |  -.0332413    .028343    -1.17   0.241    -.0887929    .0223104
          oprah  |  -.0984655   .0285432    -3.45   0.001    -.1544096   -.0425215
   pga_johndaly  |  -.0026693   .0267198    -0.10   0.920    -.0550396    .0497009
       pharrell  |  -.0236924   .0278455    -0.85   0.395     -.078269    .0308841
   realdeancain  |  -.1538387   .0316011    -4.87   0.000    -.2157762   -.0919012
  realsigourney  |    .301497   .2586427     1.17   0.244    -.2054372    .8084313
 realstaceydash  |  -.1666773   .0326434    -5.11   0.000    -.2306577    -.102697
 robertjohndavi  |  -.2111863   .0349311    -6.05   0.000    -.2796506    -.142722
       ruleyork  |  -.1505732   .0341054    -4.41   0.000    -.2174191   -.0837274
         rupaul  |  -.1512427   .0344355    -4.39   0.000    -.2187355   -.0837499
           s_c_  |   .0868492   .0636606     1.36   0.172    -.0379242    .2116226
     salmahayek  |  -.1200972   .0872676    -1.38   0.169    -.2911398    .0509454
 samuelljackson  |   .0317266   .0274553     1.16   0.248    -.0220852    .0855385
sarahksilverman  |  -.1625023   .0338505    -4.80   0.000    -.2288485   -.0961562
      scottbaio  |  -.2183349   .0323396    -6.75   0.000    -.2817199     -.15495
   shondarhimes  |  -.1580068   .0308279    -5.13   0.000    -.2184288   -.0975848
       spikelee  |  -.0974074   .0275529    -3.54   0.000    -.1514105   -.0434042
    springsteen  |   .0115692   .0309129     0.37   0.708    -.0490194    .0721578
   starjonesesq  |  -.2351421   .0322141    -7.30   0.000    -.2982812   -.1720031
  susansarandon  |  -.1597661   .0359894    -4.44   0.000    -.2303045   -.0892276
      teddanson  |  -.1559979   .0888586    -1.76   0.079    -.3301589    .0181631
      tednugent  |   .1626406   .0274793     5.92   0.000     .1087817    .2164995
   theellenshow  |  -.1528713   .0288991    -5.29   0.000    -.2095128   -.0962297
therealroseanne  |  -.1656582   .0421411    -3.93   0.000    -.2482539   -.0830625
  therealtaraji  |  -.1526624    .029535    -5.17   0.000    -.2105504   -.0947743
    tonygoldwyn  |  -.1590143   .0294031    -5.41   0.000    -.2166437   -.1013849
       uzoaduba  |  -.1333932   .0305798    -4.36   0.000    -.1933289   -.0734574
                 |
           _cons |  -.5134088   .0705379    -7.28   0.000    -.6516615    -.375156
----------------------------------------------------------------------------------
(est1 stored)

. eststo: reg standardized_rt mentionsTrump mentionsHillary mentionsBernie i.year i.c_
> id if endorsed=="Clinton",r

Linear regression                               Number of obs     =    124,865
                                                F(75, 124789)     =      80.58
                                                Prob > F          =     0.0000
                                                R-squared         =     0.0123
                                                Root MSE          =     .99391

----------------------------------------------------------------------------------
                 |               Robust
 standardized_rt |      Coef.   Std. Err.      t    P>|t|     [95% Conf. Interval]
-----------------+----------------------------------------------------------------
   mentionsTrump |   .4199704   .0408135    10.29   0.000     .3399766    .4999642
 mentionsHillary |   .3450217   .0748102     4.61   0.000      .198395    .4916483
  mentionsBernie |   .2168962   .2217416     0.98   0.328    -.2177136    .6515061
                 |
            year |
           2009  |   .1013911   .0709953     1.43   0.153    -.0377584    .2405406
           2010  |   .0832456   .0692758     1.20   0.229    -.0525338     .219025
           2011  |   .1513983    .069428     2.18   0.029     .0153205    .2874761
           2012  |   .3539363   .0693803     5.10   0.000     .2179521    .4899205
           2013  |   .4253824   .0676711     6.29   0.000     .2927483    .5580165
           2014  |   .5095421   .0690325     7.38   0.000     .3742396    .6448446
           2015  |   .6108357   .0691392     8.83   0.000     .4753239    .7463474
           2016  |   .6542109   .0695093     9.41   0.000      .517974    .7904479
           2017  |    .657223   .0701371     9.37   0.000     .5197554    .7946906
           2018  |    .649601   .0703009     9.24   0.000     .5118123    .7873896
                 |
            c_id |
   abbijacobson  |   .2121643   .0368743     5.75   0.000     .1398913    .2844373
    abbywambach  |   .0616682   .0337513     1.83   0.068    -.0044838    .1278203
          adele  |    .216915   .0632717     3.43   0.001     .0929035    .3409265
 americaferrera  |    .063003   .0354567     1.78   0.076    -.0064914    .1324975
     amyschumer  |   -.038931   .0347994    -1.12   0.263    -.1071373    .0292754
      bad_robot  |   .0908532   .0396657     2.29   0.022     .0131091    .1685973
barbrastreisand  |   .0066373   .0361706     0.18   0.854    -.0642565    .0775311
      bethbehrs  |  -.0692263   .0356041    -1.94   0.052    -.1390097    .0005571
        beyonce  |   .1486184   .2845991     0.52   0.602    -.4091911    .7064278
        bonjovi  |   .1922741    .034229     5.62   0.000     .1251858    .2593624
    carole_king  |   .1261868   .0361422     3.49   0.000     .0553487    .1970248
 charlizeafrica  |   .3232005   .0408991     7.90   0.000      .243039     .403362
           cher  |  -.1521714   .0347826    -4.37   0.000    -.2203446   -.0839981
   chloegmoretz  |  -.0720232   .0346731    -2.08   0.038    -.1399819   -.0040644
  conniebritton  |  -.0115548   .0420803    -0.27   0.784    -.0940314    .0709218
       ddlovato  |  -.0594639   .0349938    -1.70   0.089    -.1280512    .0091235
   debramessing  |  -.0802154    .045848    -1.75   0.080    -.1700766    .0096459
 elizabethbanks  |  -.0600538   .0350371    -1.71   0.087     -.128726    .0086185
  eltonofficial  |  -.0288976   .0362055    -0.80   0.425    -.0998597    .0420645
    evalongoria  |     -.0665   .0348092    -1.91   0.056    -.1347255    .0017254
    georgetakei  |  -.0942378   .0361092    -2.61   0.009    -.1650112   -.0234644
     hereisgina  |  -.0645241   .0373797    -1.73   0.084    -.1377878    .0087395
   iamjamiefoxx  |   .1048563    .035866     2.92   0.003     .0345594    .1751531
 iamsteveharvey  |  -.0639636   .0348658    -1.83   0.067    -.1322999    .0043727
imangelabassett  |   .0079883   .0390022     0.20   0.838    -.0684553     .084432
     jaime_king  |   -.074777    .034509    -2.17   0.030     -.142414   -.0071399
            jlo  |  -.0660413   .0381953    -1.73   0.084    -.1409034    .0088207
     johnlegend  |  -.0952092   .0353598    -2.69   0.007    -.1645138   -.0259046
          kaj33  |   .2703987    .037167     7.28   0.000      .197552    .3432455
      katyperry  |  -.0468643    .033679    -1.39   0.164    -.1128745    .0191459
kerrywashington  |  -.0626301   .0355285    -1.76   0.078    -.1322654    .0070051
  kimkardashian  |   -.062318   .0364719    -1.71   0.088    -.1338023    .0091662
      kingjames  |   .0736088    .033532     2.20   0.028     .0078867    .1393309
       ladygaga  |  -.0320723   .0342009    -0.94   0.348    -.0991054    .0349608
  leedanielsent  |  -.0651489   .0354795    -1.84   0.066    -.1346882    .0043904
     lenadunham  |  -.0620427   .0342941    -1.81   0.070    -.1292586    .0051733
    leodicaprio  |   .1267056   .0463094     2.74   0.006     .0359401    .2174712
        madonna  |   .0099391   .0331496     0.30   0.764    -.0550335    .0749118
   magicjohnson  |  -.0542813   .0331134    -1.64   0.101    -.1191829    .0106203
    mariahcarey  |    .003054   .0347351     0.09   0.930    -.0650263    .0711342
marysteenburgen  |  -.0140462   .0360465    -0.39   0.697    -.0846968    .0566043
     mileycyrus  |   .0143355   .0340408     0.42   0.674    -.0523838    .0810548
         mjfree  |  -.1355131    .034578    -3.92   0.000    -.2032853   -.0677409
    officialkat  |   .0488592   .0337114     1.45   0.147    -.0172145    .1149329
    oliviawilde  |    .045352   .0341171     1.33   0.184    -.0215169    .1122209
          oprah  |  -.0176927   .0335933    -0.53   0.598    -.0835349    .0481496
       pharrell  |   .0558149   .0336928     1.66   0.098    -.0102224    .1218523
  realsigourney  |   .3820743   .2608263     1.46   0.143    -.1291408    .8932894
       ruleyork  |  -.0632605   .0383117    -1.65   0.099    -.1383508    .0118298
         rupaul  |  -.0632386   .0388823    -1.63   0.104    -.1394472    .0129699
           s_c_  |   .1649298   .0672928     2.45   0.014      .033037    .2968225
     salmahayek  |  -.0450502   .0887384    -0.51   0.612     -.218976    .1288755
 samuelljackson  |   .1129195   .0339645     3.32   0.001     .0463496    .1794894
sarahksilverman  |  -.0762903   .0383902    -1.99   0.047    -.1515345   -.0010461
   shondarhimes  |  -.0709635   .0355376    -2.00   0.046    -.1406166   -.0013103
    springsteen  |   .0937254   .0366665     2.56   0.011     .0218598    .1655911
   starjonesesq  |  -.1604023    .036758    -4.36   0.000    -.2324475   -.0883572
      teddanson  |  -.0683403   .0905842    -0.75   0.451    -.2458838    .1092031
   theellenshow  |  -.0658515   .0341142    -1.93   0.054    -.1327147    .0010117
  therealtaraji  |  -.0640017   .0342206    -1.87   0.061    -.1310734      .00307
    tonygoldwyn  |  -.0718978   .0342469    -2.10   0.036    -.1390211   -.0047745
       uzoaduba  |  -.0517314   .0352108    -1.47   0.142    -.1207439    .0172812
                 |
           _cons |  -.5914893   .0738326    -8.01   0.000       -.7362   -.4467786
----------------------------------------------------------------------------------
(est2 stored)

. eststo: reg standardized_rt mentionsTrump mentionsHillary mentionsBernie i.year i.c_
> id if endorsed=="Trump",r

Linear regression                               Number of obs     =     23,755
                                                F(22, 23732)      =     261.11
                                                Prob > F          =     0.0000
                                                R-squared         =     0.0182
                                                Root MSE          =     .99109

----------------------------------------------------------------------------------
                 |               Robust
 standardized_rt |      Coef.   Std. Err.      t    P>|t|     [95% Conf. Interval]
-----------------+----------------------------------------------------------------
   mentionsTrump |    .326809   .0656898     4.98   0.000     .1980528    .4555651
 mentionsHillary |   .1389516   .0663784     2.09   0.036     .0088457    .2690576
  mentionsBernie |   .0971489   .1611718     0.60   0.547    -.2187581    .4130559
                 |
            year |
           2011  |   .0500242    .004566    10.96   0.000     .0410745    .0589738
           2012  |   .5851956   .0540718    10.82   0.000     .4792115    .6911798
           2013  |   .4911731   .0259623    18.92   0.000     .4402853    .5420608
           2014  |   .5086453   .0260959    19.49   0.000     .4574957    .5597948
           2015  |   .6097821   .0339026    17.99   0.000     .5433308    .6762334
           2016  |   .7548357   .0489031    15.44   0.000     .6589824    .8506889
           2017  |    .818005   .0427568    19.13   0.000      .734199    .9018111
           2018  |   .8292031   .0525654    15.77   0.000     .7261715    .9322347
                 |
            c_id |
   dennisrodman  |  -.1003132   .0353558    -2.84   0.005    -.1696128   -.0310135
  dratzenberger  |    .013059   .0522975     0.25   0.803    -.0894474    .1155654
      jonvoight  |  -.3199841   .2636476    -1.21   0.225    -.8367503    .1967821
           mw55  |  -.2203507   .0404416    -5.45   0.000    -.2996187   -.1410826
   pga_johndaly  |   .0238681   .0286134     0.83   0.404    -.0322161    .0799522
   realdeancain  |  -.2291009   .0484735    -4.73   0.000     -.324112   -.1340898
 realstaceydash  |  -.2342668   .0446138    -5.25   0.000    -.3217127   -.1468208
 robertjohndavi  |  -.2525602   .0449647    -5.62   0.000     -.340694   -.1644265
      scottbaio  |  -.2346143   .0428317    -5.48   0.000    -.3185672   -.1506614
      tednugent  |   .2326021   .0333261     6.98   0.000     .1672808    .2979235
therealroseanne  |  -.2439432   .0561254    -4.35   0.000    -.3539527   -.1339338
                 |
           _cons |  -.6017757    .033354   -18.04   0.000    -.6671517   -.5363997
----------------------------------------------------------------------------------
(est3 stored)

. eststo: reg standardized_rt mentionsTrump mentionsHillary mentionsBernie i.year i.c_
> id if endorsed=="Sanders",r

Linear regression                               Number of obs     =     11,740
                                                F(16, 11723)      =      13.53
                                                Prob > F          =     0.0000
                                                R-squared         =     0.0149
                                                Root MSE          =     .99293

---------------------------------------------------------------------------------
                |               Robust
standardized_rt |      Coef.   Std. Err.      t    P>|t|     [95% Conf. Interval]
----------------+----------------------------------------------------------------
  mentionsTrump |   .1117584    .059689     1.87   0.061     -.005242    .2287589
mentionsHillary |   .2257572   .2985555     0.76   0.450    -.3594612    .8109757
 mentionsBernie |   .3174054   .2238017     1.42   0.156    -.1212832     .756094
                |
           year |
          2012  |   .0528359   .0226744     2.33   0.020     .0083904    .0972815
          2013  |   .2022054   .0784769     2.58   0.010     .0483775    .3560332
          2014  |   .3452304   .0607478     5.68   0.000     .2261546    .4643062
          2015  |    .330733   .0517431     6.39   0.000     .2293079    .4321582
          2016  |   .5294074   .0592291     8.94   0.000     .4133084    .6455063
          2017  |   .3921393   .0703248     5.58   0.000      .254291    .5299876
          2018  |   .3843047   .0659504     5.83   0.000     .2550308    .5135785
                |
           c_id |
        emrata  |  -.2697249   .0583975    -4.62   0.000    -.3841937    -.155256
    justinlong  |  -.2343887   .0599133    -3.91   0.000    -.3518288   -.1169486
   markruffalo  |   -.306014    .074837    -4.09   0.000     -.452707    -.159321
     miafarrow  |  -.3153536   .0704094    -4.48   0.000    -.4533677   -.1773395
      spikelee  |  -.2939222   .0589063    -4.99   0.000    -.4093883    -.178456
 susansarandon  |  -.3459458   .0693977    -4.98   0.000    -.4819768   -.2099147
                |
          _cons |  -.0945748   .0019907   -47.51   0.000    -.0984769   -.0906726
---------------------------------------------------------------------------------
(est4 stored)

. esttab using signif_tests.csv, t b(%5.2f) r2 nogaps obslast star(* 0.01) label repla
> ce
(output written to signif_tests.csv)

. 
. *****************
. * TABLE 3
. *****************
. tabstat observation if endorsed=="Clinton" & mentionsTrump==1, s(sum)

    variable |       sum
-------------+----------
 observation |      2278
------------------------

. tabstat observation if endorsed=="Clinton" & mentionsHillary==1, s(sum)

    variable |       sum
-------------+----------
 observation |       797
------------------------

. tabstat observation if endorsed=="Clinton" & mentionsBernie==1, s(sum)

    variable |       sum
-------------+----------
 observation |        98
------------------------

. 
. tabstat observation if endorsed=="Trump" & mentionsTrump==1, s(sum)

    variable |       sum
-------------+----------
 observation |       646
------------------------

. tabstat observation if endorsed=="Trump" & mentionsHillary==1, s(sum)

    variable |       sum
-------------+----------
 observation |       192
------------------------

. tabstat observation if endorsed=="Trump" & mentionsBernie==1, s(sum)

    variable |       sum
-------------+----------
 observation |         6
------------------------

. 
. tabstat observation if endorsed=="Clinton", s(sum)

    variable |       sum
-------------+----------
 observation |    124865
------------------------

. tabstat observation if endorsed=="Trump", s(sum)

    variable |       sum
-------------+----------
 observation |     23755
------------------------

. tabstat observation if endorsed=="Sanders", s(sum)

    variable |       sum
-------------+----------
 observation |     11740
------------------------

. 
. *****************
. * TABLE 4A
. *****************
. tabstat observation if endorsed=="Clinton" & year==2016, s(sum)

    variable |       sum
-------------+----------
 observation |     26909
------------------------

. tabstat observation if endorsed=="Trump" & year==2016, s(sum)

    variable |       sum
-------------+----------
 observation |      3045
------------------------

. tabstat observation if endorsed=="Sanders" & year==2016, s(sum)

    variable |       sum
-------------+----------
 observation |      1866
------------------------

. 
. tabstat observation if endorsed=="Clinton" & mentionsTrump==1 & year==2016, s(sum)

    variable |       sum
-------------+----------
 observation |       408
------------------------

. tabstat observation if endorsed=="Clinton" & mentionsHillary==1 & year==2016, s(sum)

    variable |       sum
-------------+----------
 observation |       593
------------------------

. tabstat observation if endorsed=="Clinton" & mentionsBernie==1 & year==2016, s(sum)

    variable |       sum
-------------+----------
 observation |        22
------------------------

. 
. tabstat observation if endorsed=="Trump" & mentionsTrump==1 & year==2016, s(sum)

    variable |       sum
-------------+----------
 observation |       226
------------------------

. tabstat observation if endorsed=="Trump" & mentionsHillary==1 & year==2016, s(sum)

    variable |       sum
-------------+----------
 observation |       117
------------------------

. tabstat observation if endorsed=="Trump" & mentionsBernie==1 & year==2016, s(sum)

    variable |       sum
-------------+----------
 observation |         5
------------------------

. 
. *****************
. * TABLE 4B
. *****************
. tabstat observation if endorsed=="Clinton" & year>=2017, s(sum)

    variable |       sum
-------------+----------
 observation |     54194
------------------------

. tabstat observation if endorsed=="Trump" & year>=2017, s(sum)

    variable |       sum
-------------+----------
 observation |     11832
------------------------

. tabstat observation if endorsed=="Sanders" & year>=2017, s(sum)

    variable |       sum
-------------+----------
 observation |      4404
------------------------

. 
. tabstat observation if endorsed=="Clinton" & mentionsTrump==1 & year>=2017, s(sum)

    variable |       sum
-------------+----------
 observation |      1841
------------------------

. tabstat observation if endorsed=="Clinton" & mentionsHillary==1 & year>=2017, s(sum)

    variable |       sum
-------------+----------
 observation |       103
------------------------

. tabstat observation if endorsed=="Clinton" & mentionsBernie==1 & year>=2017, s(sum)

    variable |       sum
-------------+----------
 observation |        48
------------------------

. 
. tabstat observation if endorsed=="Trump" & mentionsTrump==1 & year>=2017, s(sum)

    variable |       sum
-------------+----------
 observation |       413
------------------------

. tabstat observation if endorsed=="Trump" & mentionsHillary==1 & year>=2017, s(sum)

    variable |       sum
-------------+----------
 observation |        62
------------------------

. tabstat observation if endorsed=="Trump" & mentionsBernie==1 & year>=2017, s(sum)

    variable |       sum
-------------+----------
 observation |         1
------------------------

. 
. 
. * Non-political tweets
. tabstat retweet_count if mentionsHillary==0 & mentionsTrump==0 & mentionsBernie==0, 
> by(endorsed) s(median mean)

Summary for variables: retweet_count
     by categories of: endorsed 

endorsed |       p50      mean
---------+--------------------
 Clinton |        73  906.7918
 Sanders |        25  207.7511
   Trump |         5  62.89235
---------+--------------------
   Total |        47  732.2507
------------------------------

. 
. log close
      name:  <unnamed>
       log:  /Users/jz981/Google Drive/Celebrity_Politics_JZ_JT/Deliverables/celebrity
> _analysis.log
  log type:  text
 closed on:   2 Apr 2019, 13:09:22
--------------------------------------------------------------------------------------
